<div id="menu">
	<div id="tieude">
    	<span>Kiểu Tour</span>
    </div>
	<ul id="danhsach_con">
    	<?php
			$sql=$mysqli->query("select MA_KIEU,TEN from qldl_kieu_tour ");
			while ($row=$sql->fetch_array()){
				echo "<li>
						<a href='index.php?id=chi_tiet_kt&page=".$row['MA_KIEU']."'>Du lịch&nbsp;".$row['TEN']."</a>
						</li>";
    	    }
		?>
    </ul>               
</div>                  

<div id="menu">
	<div id="tieude">
    	<span>Điểm hấp dẫn Trong nước</span>
    </div>
    <ul id="danhsach_con">
    	<?php
			$sql=$mysqli->query("SELECT qldl_dia_diem_du_lich.DIA_DIEM,qldl_dia_diem_du_lich.MA_DIA_DIEM
								FROM qldl_dia_diem_du_lich 
								inner join qldl_tinh_thanh_pho
								on qldl_dia_diem_du_lich .ma_tp = qldl_tinh_thanh_pho.ma_tp
								inner join qldl_quoc_gia 
								on qldl_quoc_gia.ma_quoc_gia = qldl_tinh_thanh_pho.ma_quoc_gia
								where ma_loai =1
								AND DIEM_HD =1 ");
			while ($row=$sql->fetch_array()){
				echo "<li>
						<a href='index.php?id=chi_tiet_dtn&page=".$row['MA_DIA_DIEM']."'>Du lịch&nbsp;".$row['DIA_DIEM']."</a>
						</li>";
			}
		?>
	</ul>
</div>

<div id="menu">
	<div id="tieude">
    	<span>Điểm hấp dẫn Nước ngoài</span>
    </div>
	<ul id="danhsach_con">
    <?php
		$sql=$mysqli->query("SELECT qldl_dia_diem_du_lich.DIA_DIEM,qldl_dia_diem_du_lich.MA_DIA_DIEM
							FROM qldl_dia_diem_du_lich 
							inner join qldl_tinh_thanh_pho
							on qldl_dia_diem_du_lich .ma_tp = qldl_tinh_thanh_pho.ma_tp
							inner join qldl_quoc_gia 
							on qldl_quoc_gia.ma_quoc_gia = qldl_tinh_thanh_pho.ma_quoc_gia
							where ma_loai =2
							AND DIEM_HD =1 ");
		while ($row=$sql->fetch_array()){
			echo 	"<li>
					<a href='index.php?id=chi_tiet_dnn&page=".$row['MA_DIA_DIEM']."'>Du lịch&nbsp;".$row['DIA_DIEM']."</a>
					</li>";
		}
	?>
 	</ul>
</div>

<div id="menu">
	<div id="tieude">
    	&nbsp;Số lượt xem trang&nbsp;
    	<img src="http://hitwebcounter.com/counter/counter.php?page=5828812&style=0006&nbdigits=5&type=page&initCount=0" title="gerEGGe" Alt="gerEGGe"   border="0" >
    </div>
</div>

<?php
   	$sql = "SELECT  qldl_tour.HINH_ANH
			FROM qldl_tour
			INNER JOIN qldl_chi_tiet_tour 
			ON qldl_tour.ma_tour = qldl_chi_tiet_tour.ma_tour
			INNER JOIN qldl_dia_diem_du_lich 
			ON qldl_chi_tiet_tour.ma_dia_diem = qldl_dia_diem_du_lich.ma_dia_diem
			INNER JOIN qldl_tinh_thanh_pho 
			ON qldl_tinh_thanh_pho.ma_tp = qldl_dia_diem_du_lich.ma_tp
			INNER JOIN qldl_quoc_gia 
			ON qldl_quoc_gia.ma_quoc_gia = qldl_tinh_thanh_pho.ma_quoc_gia
			WHERE ma_loai =1 order by qldl_tour.ma_tour limit 0,2";
	$result=$mysqli->query($sql);
  	while ($row=$result->fetch_array()){
		echo"<div id='quangcao'>
          	<img src='admin/tour/upload/news/".$row['HINH_ANH']."' id='quangcao_hinhanh'>
            </div>";
	}
?>